package com.example.easypoi.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.example.easypoi.model.Bank;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * @description:
 * @author: 朱超
 * @createDate: 2023/7/3
 * @version: 1.0
 * @remark：备注
 */
@Mapper
public interface BankMapper extends BaseMapper<Bank> {

    Integer AddBank(@Param("bankList") List<Bank> bankList);


    Integer AddBankTest(@Param("bankList") List<Bank> bankList);




    /**
     * 导出信息
     */
    @Select("SELECT co.bank_name,co.of_the_public,bn.branch_id,bn.bank_no,bn.branch_name FROM t_bank_code co INNER JOIN t_bank bn ON co.bank_no=bn.bank_no where co.of_the_public=#{ofThePublic}")
    List<Bank> queryList(Integer ofThePublic);
}
